The company consist of 2 non-financial sites linked to a financial site. For each non-financial site a seperate stock account is users, to show the stock per site on the balance sheet.

I would use modifiers to drive the different accounts.

You could use the method you originally thought of with unique accounting codes but I suggest that you use miscellaneous stock receipts journal and transaction for your testing. Add conditions to the accounting code grid to pick the lines. You don't need to add extra lines

I would use modifiers to drive the different accounts.

You could use the method you originally thought of with unique accounting codes but I suggest that you use miscellaneous stock receipts journal and transaction for your testing. Add conditions to the accounting code grid to pick the lines. You don't need to add extra lines

Thanks for the direction. What is meant by Modifier?

If you had two inventory accounts 123100 and 123200 for different sites you can create part of the account in the product accounting code and part in the site accounting code.

product code line 12 can be 123XXX

Site code line 1 can be XXX100 for site A and XXX200 for site B (I used line 1 but you can add a new line if you wish)

On your Inventory journal line for the auto journal set it like this

X3 will read the first 3 characters from the product and last 3 from the site and ignore the XXXs. 

Accounting code must be set to modifier but that is the default anyway.

Thanks! This work very nicely.

Hi Braam, if the above suggested answer helped, please do mark it as verified  for the benefit of others in this forum :). Thank you!

 If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey