Distribution, Manufacturing, and Internet Modules

[potteryboss]

For some unknown reason one day at the end of January EVERY GL account assignment for EVERY Product Line was set to my Cost Of Goods Sold account.

I can correct them but now I wonder if I can rely on them staying that way.

Also, when and where does the GL account assignment to an item sold apply?  Does this happen when upon order entry or upon invoicing in S/O?  Will I be haunted by this error from now until every order I have in my system is invoiced or does fixing the account assignments in IM fix any future invoices?

[DFeller · Accepted solution]

I have never heard of this happening before.

When you create a S/O, it copies in the GL accounts from that item into the S/O.  So if they were wrong in product line maintenance, then they would be wrong in the S/O which would carry into the invoice.

Dawn

[TomTarget]

You can change the sales account and the cogs account on the existing sales orders by manually correcting them (hopefully there are not too many of them).

If the inventory accounts are wrong,  I don't think these are stored in the sales orders,  but are picked up for posting at the time the invoices are updated so it get's its information by looking up in the product lines and warehouse code settings.  I'm not 100% positive of this however in the past I have had clients want to gain some extra control over the inventory accounts during a V/I import and I could not find a field for it in the sales order/invoice data entry files.  I could do just about anything with the sales and COGS accounts, but not the inventory accounts.

[potteryboss]

Thank you for the reply.  Fortunately the cost account can't actually be wrong.  I only have one and it was used for everything.

Unfortunatety I'll have to manually correct thousands of line items sales accounts numbers.  I can't really pass this off to anyone else either becauser I'm the only one who can look at an item number and know the sales account.

[potteryboss]

Unfortunatety I'll have to manually correct thousands of line items sales accounts numbers.  I can't really pass this off to anyone else either becauser I'm the only one who can look at an item number and know the sales account.

[DFeller]

I have previously written a script (using Microsoft Access) that used BOI to update sales order line items to the G/L account in product line maintenance (once those accounts were correct).

Dawn