Is there a way to get a PO-direct to customer to hit the COGS account instead of the RNI?

SOLVED

I must be missing something, or forgetting something, because I am baffled that a Direct to Customer PO invoice would DR the RNI account when there is no receipt.  In fact, the programming won't allow you to create a receipt. 

The account is defaulted by the purchase type, which then looks to the accounting code.  If I change the line of the accounting code to the COGS, then it is true for every situation, which will throw off the RNI in a normal receive and ship transaction.  
 

I have tried an Action workflow, but I was unable to get it to change the account.  [This is my preferred method.] 

Does it really involve customizing an Auto Journal at invoicing to CR the RNI and DR COGS? 

I really hope that I am missing something obvious, and that someone could point me in the right direction.

Thank you

Parents
  • 0

    Hi

    I Just did this in SEED. Created a customer order for site GB012, sold to GB011. Product code: BMS002 and selected back to back order. (Infact I copied order SONGB0120030 on SEED), so just use that order number (patch 32) copy/amend to back to back and save.

    I then clicked Back-to-back order to generate the PO which created for me under supplier DE053

    Then I invoiced that PO. 

    It credited PL control account and debited 700000: Cost of Sales. Also debit and credited VAT accounts. 

    So seems to work as expected in the SEED folder? the auto journal that was triggered was PIHI2.

    Might be worth you tracing that through to see the setup of those things and why that worked where yours did not.

    I'm going to make a guess that there's some auto journal with criteria based on LINPURTYP that only triggers for these back to backs but I don't have free reference auto journal lines turned on in my demo folder to check which line was called specifically and don't want to go down that mine field at the moment Slight smile

    Hope that helps a little.

Reply
  • 0

    Hi

    I Just did this in SEED. Created a customer order for site GB012, sold to GB011. Product code: BMS002 and selected back to back order. (Infact I copied order SONGB0120030 on SEED), so just use that order number (patch 32) copy/amend to back to back and save.

    I then clicked Back-to-back order to generate the PO which created for me under supplier DE053

    Then I invoiced that PO. 

    It credited PL control account and debited 700000: Cost of Sales. Also debit and credited VAT accounts. 

    So seems to work as expected in the SEED folder? the auto journal that was triggered was PIHI2.

    Might be worth you tracing that through to see the setup of those things and why that worked where yours did not.

    I'm going to make a guess that there's some auto journal with criteria based on LINPURTYP that only triggers for these back to backs but I don't have free reference auto journal lines turned on in my demo folder to check which line was called specifically and don't want to go down that mine field at the moment Slight smile

    Hope that helps a little.

Children