Skip to main content

Notifications

Business Central forum
Suggested answer

How to import Recurring Purchase Lines for multiple vendors at a time?

Posted on by 174
We have a large list of vendors with default purchase accounts, so we are using the Recurring Purchase Lines feature to show a specific GL account with 1 or more departments on Purchase Invoices. I know how to set these up individually, but what is the process for importing these for multiple vendors at a time?
 
I've attempted a configuration package with the Vendors table and Recurring Purchase Code table, but when I attempt to import the Excel file, I receive an error stating the "Purchase Codes don't exist." This is confusing, because I'm trying to create those purchase codes in bulk, but the configuration package can't handle that? There are 15-40 different recurring purchase lines I need to create and then assign to vendors, and I need to repeat the process for 8 different companies. Does this have to be done manually?
 
If someone has done this before, could you walk through the steps? I've successfully imported data into other tables with configuration packages, but I've manually imported Recurring Purchase Codes for every implementation.
Categories:
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 63,013 Super User on at
    How to import Recurring Purchase Lines for multiple vendors at a time?
    I think it's a problem with the order of application. You should import Recurring Purchase Code first and then Vendor and there should be no problem.
    As long as the data before posting, it can be imported through Configuration Package, but you need to pay attention to the order of import.
     
    Hope this helps as well.
    Thanks.
    ZHU
  • ERPlatanos Profile Picture
    ERPlatanos 174 on at
    How to import Recurring Purchase Lines for multiple vendors at a time?
    Thanks, Valentin!
     
    I will attempt and get back to you!
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 6,365 Super User on at
    How to import Recurring Purchase Lines for multiple vendors at a time?
    It can work with configuration packages, you need to import them in the correct order. Import table 173 first, then 174, and lastly 175.
     

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,876 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,425 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans