Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Import purchase order as flat file

Posted on by Microsoft Employee

Hi,

I am writing a tool which imports purchase orders into Dynamics SL. I cannot seem to find any description of the input file format. Do you know what this format is called? Is there an official document where its structure is described? I need to generate these files, and it's not easy just going by examples. Here's one:

POSTART   850015415ZZ925485US00                                               850015415               473133GT                                       0001     00SA1304741007                                                            2017/02/02                                                                                              473133090                                                                                                                                                                      00009                                                                                                                                                                     0003                                                                                                     STRLAGWK05                                                                                                                                                                                                                                                                       CCORONTARIO CA                  CA                                                         08 15     1           20           60                                                                                                                       2017/02/28                                                                                          2017/02/072017/02/09          O                                                                                        CALL4792734300#                                                                                      1                                                             144
CONTACT                                                                                                                                                                                                                                                                                                                                                 
HDISCOUNT A                 02                                                 1.44     6     1                                                                                                                                  F910
ADDRESS   BY WAL-MART DC 6026G-GENERAL                                   UL0078742030012                                                                                                                                                                                                                                                                                                                   10817 HWY 99W                                                                                                                                                                                                               RED BLUFF                     CA96080          US
ADDRESS   BT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
ADDRESS   ST                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
ADDRESS   SU EYE OJO CORP                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
LINEITEM  001                               1     EA                  144   LEIN 556108343                                       UP 666197833137                                    VN SKI-PDQ12                                                                                                                                                                                                                                                                                                      UK 00666197833137                                                                                                      144
SUBLINE                                     1     EA                          IN 556077329                                       UP 666197833113                                    VN RSKI-MD17                                                                                          IZ 1.0                                             UK 00666197833113                                                                                     
SUBLINE                                     4     EA                          IN 556077330                                       UP 666197833106                                    VN RSKI-LG17                                                                                          IZ 1.0                                             UK 00666197833106                                                                                     

*This post is locked for comments

  • Apps Mexico Profile Picture
    Apps Mexico 1,090 on at
    RE: Import purchase order as flat file

    Hi Anton,

    To do that with SL Screen's you have to use the Transaction Import (98.500.00) screen, first you have to create a control file with the Crete File Control (98.510.00) screen. When you have the ctl file, you habe to change your code to create a .dta file that match with de .ctl file definition. You can look the documentation por that screen's.

    Now if you need a process that do purchase orders directly on the dabase without screens, I can give a demo and a quote of a store procedure that creates purchase ordes.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans