Define purchase account in perpetual SAP B 1

[Former Member]

Dear experts,

We are using SAP Business One for HANA, v.2.0 PL 6.0 and continuous stock system setup.

Let’s assume that we purchase an item e.g. Item A (which is an inventory item) from a vendor within the European Union. When posting the A/P invoice, with the generated journal entry a specific account (e.g. account XXX : Purchase Account - EU) is debited with the amount of the purchase value.

In case we purchase the same item from a vendor in foreign countries (outside the EU) when posting the A/P invoice a different account should be debited (e.g. account YYY : Purchase Account – Foreign). However, the same purchase account is debited in all cases.

Is this correct? How can we differentiate the transactions between the account of purchases within the EU and the account of purchases outside the EU?

Any advice would be helpful.

Thank you in advance.

Vassilis Korolis

[anto34270]

did you have a solution?

6 year later, same issue here !

[JesperB1]

Hello Anthony,

Without getting too much into details, have you tried advanced GL Account Determination?

Blog Post

How to Guide

I have not investigated the specific scenario but this is a good starting point I believe.

I hope it helps,

Jesper