Topic Options
#15591 - 01/09/09 04:14 PM Posting Physical Inventory
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
When physical inventory is posted, what GL account does it post the adjusment amount to? Is there a way to edit the account? We have an account 5025 set up that we use all year for inventory adjustments and want to use the same account so we can keep tracking of total inventory losses or gains.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#15593 - 01/09/09 04:46 PM Re: Posting Physical Inventory [Re: SusanTennier]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
Hi Susan,

Posting a physical inventory hits the 'Adjustment write off' and 'Inventory control' accounts as assigned on the Control Account Set of the item, just like for Adjustment transactions. If you edit the Control Account Set, you can change the Adjustment Write Off account if you which.

As long as all Control Account Sets (if you have more than one) use the same Adj W/O account, then you can do what you require.
_________________________
Regards,
Softrak Tech Support

Top
#15599 - 01/09/09 09:18 PM Re: Posting Physical Inventory [Re: Softrak Support]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
This sounds good. I will change the Adjust Write Off account to 5025 in the control account sets. We have another write off account 5430 that POA uses as some sort of in and out account. In POA Company Profile/Interface Posting Options it says that 5430 is used for "General Ledger Rounding Error Account". What does that mean?
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#15610 - 01/12/09 11:26 AM Re: Posting Physical Inventory [Re: SusanTennier]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11532
Loc: Vancouver, BC Canada
I believe this has to do with occasions where due to 'rounding errors' and the sum of the details may differ from the total amount by a penny or two, a rounding G/L account is available to post to. This often heppens with MultiCurrency where exchange rate conversions are involved.

This would be similar to the rounding account one might see in A/R control account sets when multicurrency is enabled.

There may be a more clear answer that another may wish to provide.
_________________________
Regards,
Softrak Tech Support

Top
#15625 - 01/12/09 05:57 PM Re: Posting Physical Inventory [Re: SusanTennier]
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1736
Loc: Waterloo, Ontario, Canada
Hi,

The rounding account in POA is used primarily for rounding the allocations of miscellaneous charges that do not divide out evenly between the line items, depending upon how you allocate the miscellaneous charges. It should normally be just pennies.

It is also used for rounding on Multicurrency, to make the debits and credits balance, again depending upon the allocation of the rate factor. And should be normally just pennies as well.

We have always suggested that this account be linked to Cost of Sales.

Regards,
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top
#15636 - 01/13/09 03:07 PM Re: Posting Physical Inventory [Re: Brian Stief]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Thanks for the info. The rounding account has not accumulated very much however since there are so many transactions in there I still like the idea of keeping our inventory adjustments in a separate account which is why we set up an account called 5025 Inventory Adjustments. With this understanding, I think I will go ahead and change the control account sets in Inventory to 5025.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 48 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30