Separate Account Payable when posting Purchase Invoice

Chika

Dear All,

I'm implementing financial management module for my new customer
in Indonesia. They have a unique requirement for the VAT.

For e.g. There is a purchase invoice for Vendor. The amount is 1000 and
there is VAT 10%.
But they want the journal to be like this when user posting the purchase
invoice:


Purchase 1000 [D]
VAT IN 100 [D]
Account Payable 1000 [C]
Account Payable2 100 [C]
and in vendor master, balance should be 1000 only for this vendor,
because the rest 100 will be total AP for the other vendor.
This requirement is needed because they pay 100 for the government directly, means that the vendor don't pay the VAT to the government.

Can anyone give me suggestion how to do this?
Should we modify NAV to meet this requirement?

Regards,
Chika

ara3n

Hello Chika.

You will need to modify NAV.

The way I would go about implementing this is add a new field on sales header called VAT-BillToCustomer

Modify CU 80

Search for
// Post customer entry

and

modify to only include Amount

GenJnlLine.Amount := -TotalSalesLine."Amount Including VAT";
GenJnlLine."Source Currency Amount" := -TotalSalesLine."Amount Including VAT";
GenJnlLine."Amount (LCY)" := -TotalSalesLineLCY."Amount Including VAT";


Create a new a new GenJnlLine. that would post the VAT-BillToCustomer

selece28

Hi ara3n,
I'm also having the same problems,
With this mod, is the vendor's AP is still including the VAT?
Because we need to split so that the AP is just the sales and the VAT will go into the Goverment's AP.

Please advice,
Thanks in advance

Sumit

With out doing any modification,
can we try the following available functionality:
it is like, After receipt, Go to Purchase Invoice card> create New.
(keeping Buy-from Vendor remain same.)
create two invoices, but in one, Bill-to Vendor= Buy-from Vendor,
In the other Bill-to Vendor= Govt. Dept. (Create a new vendor=Govt. Dept.)
In 2nd invoice/Vendor with only charge (item) line. (Create a charge (item)=Vat)
for that LINE
Go to Line > Item Charge Assignment > Action> Functions >Get receipt Lines.
As per Bill-to, we can have Vendor AP= 1000 & Govt.Dept AP=10