How do we raise Incoming Excise invoice on Vendor1 and A/P Invoice on Vendo

[former_member418241]

Hi All,

How do we raise Incoming Excise invoice on Vendor1 and A/P Invoice on Vendor2 for a single purchase order?

The Scenario: PO is raised on Vendor2 for certain goods excisable and Vendor2 is not registered under Excise hence i cannot get Incoming excise invoice from Vendor2 or I cannot raise Excise invoice in B1 on the name of Vendor2.

But

the same goods (which are excisable) were already supplied by Vendor1 to Vendor2. So here the excise invoice is coming from Vendor1 and A/P Invoice from Vendor2 how this is actually handled in Business One? How do we show the A/P Invoice amount due on Vendor2 and the Excise Passed from Vendor1?

Thanks

SV Reddy

[Former Member]

Hai!

Check this link this will work for Supplier also

https://www.sdn.sap.com/irj/scn/wiki?path=/display/b1/differencebetweentheConsolidationOptionsintheBusinessPartnerMasterData

[former_member418241]

Hi Thanga Raj,

what you said is works only for payment consolidation. where in a particular purchase two vendors are involved, the tax updates should go into relevant vendor master data. in the above case excise is updated in the vendor1 account and RG23 also should be generated on the name of Vendor1.

Since you already raising incoming excise invoice on the name of Vendor1 you also need to raise A/P Invoice on Vendor1 (this is mandatory, from the goods receipt PO when you click copy to Incoming Excise Invoice and A/P Invoice the system automatically inserts "Vendor1")

but how do you update the Vendor2 account only for the A/P Invoice VAT portion. Because in reality the VAT you are paying to Vendor2 since you need to raise the a/P Invoice on the name of Vendor2. it is not actually happening in business one. If you try to raise A/P Invoice on Vendor2 from this Goods Receipt PO, initially the system copies Vendor1 from GRPO and if you change and try to add the invoice on Vendor2 name, the system will ask you to create a serial number again if the item is excisable. here the work is duplicated for the same item you already created a serial number while you creating the Goods Rectipt PO from Vendor1.

Any body knows any other scenario please help me.

Thanks

SV Reddy

[Former Member]

Hai!

Please Try this..

1. Create a Vendor V1.

2. Create a Vendor V2.

3. For V2 on Accounting Tab >> Consolidate BP>> select V1 and Option as Delivery Consolidation.

4. Book a Purcahse Order to V1 for an Excise Item.

5. Book GRPO Based on the PO.

6. Book Excise Invoice based on GRPO.

7. Go to Modules >> Purchase A/P >> A/P invoice.

8. Select BP as V2.

9. Click Copy From GRPO.

10. You will get the list of GRPO's raised for V1. select your GRPO.

11. Copy the GRPO and add the invoice.

This is Delivery Consolidation.

As u said, GRPO and Exsice raised on the name of V1 and Invoice raised on V2.

Give ur feedback

Regards,

Thanga Raj.K

[Former Member]

Hi,

I do completely agree with Mr Thanga

Regards,

Mukesh

[former_member418241]

Hi Thanga Raj, thanks for your good reply,

It works well with little change for what you said. since the A/P invoice need to be raised on Vendor2 the delivery consolidation need to be done for Vendor1 master record not for Vendor2. For Vendor1 master record, in the accounting tab-delivery consolidation-vendor2 need to be entered.

when you create A/P invoice on Vendor2 using copy from Goods Receipt PO the system will display the Goods Receipto PO which was raised on Vendor1 name.

thanks for good reply. points assigned.

SV REDDY