Skip to main content

Notifications

Business Central forum
Suggested answer

To import Purchase Invoices and payment together

Posted on by 87
Hello,
 
I have a requirement to create extension to import the following into Purchase Invoices.
 
!HeaderHeaderIDTypeDateAccountVendorNo DescriptionAmountDocument No
!LineLineIDTypeDateAccountNameAmountDocument No
!EndHeader      
Header CHECK09/13/2023
1120
30000 CoolWood Technologies-202 
Line CHECK09/13/2023
9610
Test100 
Line CHECK09/13/2023
9610
Test104 
Line CHECK09/13/2023
9610
Test-2 
EndHeader      
 
I am able to create extension, but there is issue with the provided data.
1. Firstly , No Document number is provided which is required to map with the lines
2. In Type ,/Check/ is provided which gives me indication that it is not invoice but payment.
3. While uploading to purchase line, I am using /Type/= 'G/L Account' and /No/ as /9610/.
I am unable to figure out, how will my extension effect Charts of Account without uploading payments for the same?
Or is there a way to upload payments with purchase invoices ?
 
 
  • BBC_dhanvi Profile Picture
    BBC_dhanvi 87 on at
    To import Purchase Invoices and payment together
    Thank you for the feedback, 
    I also had the same thought this. But the company wants to import CHECK in invoices and EFT in General Journal.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,095 Super User 2024 Season 2 on at
    To import Purchase Invoices and payment together
    If you import this data when opening this invoice, it should be possible because the current invoice number can be found.
    Also, this looks like a Payment Journal, not an invoice. 
    I think you should discuss with the company that provides this data in what form you want it to be imported into BC.
     
     
    Hope this can give you some hints.
    Thanks.
    ZHU

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,115 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,971 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans