How to enter opening balance of supplier in AP?

[SSalman SSadiq]

Dear All,
Some body please tell me how to enter opening balance of supplier in AP. Thanks in advance

[vinodgayatyri]

Hi Salman,


Firstly Excel template we have to prepare in that template we have to map the fields related to suppliers .EG Supplier Name ,Supplier ID,TAX,INV NO, Amount.

we have to give it to the business to fill the respective fields and ones the business gives the Excel sheet with complete information we have to cross verify and see whether all the required information is correct or wrong or all the mandatory fields are filled or not.


Then we have to give it to the technical person in a CSV.. format he will upload the open invoices in Application.

Ones he uploaded all the open invoices in application we have to run the Trail balance report in oracle and we have to cross check with the Excel sheet whether both are matching or not

trial balance Creditors in GL and and AP trial balance should match.


Note : in ap we cannot upload Payments.




Regards
V.Vinod

[tgs100]

Basically you need to upload the open transactions for the supplier (unpaid or partially paid transactions) with the balance amount as AP Invoices.

Cheers,
Saravanan TG

[nrao1981]

[quote]Basically you need to upload the open transactions for the supplier (unpaid or partially paid transactions) with the balance amount as AP Invoices.

Cheers,
Saravanan TG

<i><div align="right">Originally posted by tgs100

[tgs100]

You will be uploading as standard invoice or credit memo or prepayment invoices depending on the invoice type. First you should upload it to the interface table and then you will be importing into the standard tables using the standard concurrent program.

Cheers,
Saravanan

[hiszaki]

Hi

In upload payment, you can upload the payment using data loader because the AP payment doesn't have interface table according to my knowledge.

Thanks
Hisham