Is there a way to import inventory adjustments wit...
# general
a
Is there a way to import inventory adjustments without adjusting any accounts?
s
The adjustment has to have an account to balance against the inventory going down
r
No, inventory adjustments impact your GL, you have to have a contra account to the inventory assets. I'm curious what you're trying to accomplish.
s
I believe it is fairly common people have a COGS account specifically for inventory adjustments, though.
a
I'm implementing netsuite and already have the GL entries. I don't want to double count.
r
Both adjustments and worksheets are GL impacting transactions. Best bet is to let your adjustments drive your accounts then perform reconciliation if needed. The contra account is typically an opening balance account
a
Wouldn't that mean that I have to change the asset account for each one?
r
Asset is driven by the item master
the account selected in the transaction should be the opening balance account
a
What account is on the other side though? Forgive me, I am way under qualified for my job.
r
np... on the item master, you set the Asset account which will be debited when doing the positive adjustment. When performing the the inventory adjustment, you select the Opening Balance account which will be credited.
a
I have hundreds of items...