I'm working with a UK client who wants to use an account for both sales invoices and for vendor ledger entries. By vendor ledger entry, I mean that we post a set of general journal lines which end up in the Vendor Ledger Entries archive. We're having trouble with configuring the account in a way that it works for both:
Scenario #1:
- The account's Gen. Posting Type, Gen. Bus. Posting Group, Gen. Prod. Posting Group, VAT Bus. Posting Group, and VAT Prod. Posting Group are all blank.
- Trying to post a sales invoice which uses that account gives an error stating "Gen. Prod. Posting Group Must Have Value in Sales Line".
Scenario #2:
- The account's Gen. Posting Type is blank, while the Gen. Bus. Posting Group, Gen. Prod. Posting Group, VAT Bus. Posting Group, and VAT Prod. Posting Group have values.
- Trying to post a vendor ledger entry which uses that account gives an error stating "Posting to Account X must either be of type Purchase or Sale (see Gen. Posting Type), because there are specified values in one of the following fields: Gen. Bus. Posting Group, Gen. Prod. Posting Group , VAT Bus. Posting Group, or VAT Prod. Posting Group".
Scenario #3:
- The account's Gen. Posting Type is set to Sale, and the Gen. Bus. Posting Group, Gen. Prod. Posting Group, VAT Bus. Posting Group, and VAT Prod. Posting Group have values.
- Trying to post a vendor ledger entry which uses that account gives an error stating "Gen. Posting Type must not be Sale in Gen. Journal Line".
Is there any way to setup this account to work for both transaction types? This affects at least a few other accounts too, so a more global solution such as General Posting Setup would be fine.