x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 4 replies
  • Subscribers 60 subscribers
  • Views 3585 views
  • Users 0 members are here
Browse Forums
Announcements
78
topics
166
replies
General Discussion
5k
topics
16k
replies
Installation and Upgrades
979
topics
2k
replies
Inventory, Projects, and Departments
339
topics
1k
replies
Payables and Receivables
1k
topics
4k
replies
Payroll
1k
topics
3k
replies
Reconciliation and Banking
318
topics
997
replies
Reporting and Analytics
207
topics
400
replies
Soutien Technique - Français
629
topics
1k
replies
Year End Activities
224
topics
596
replies
RailiM

Import Purchase Invoices (AP) from a text file.

Posted By

I want to import Purchase Invoices (AP) from a text file. The Knowledgebase says this:

From https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=10186&sliceId=1&cmd=displayKC&dialogID=105647&docType=kc&isLoadPublishedVer=&stateId=105649&docTypeID=DT_Article&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl

This articles describes how to import general journal entries only from a text file (CSV). Sage 50-Canadian Edition does not provide a text file method of importing actual transaction details such as invoices. If you have a third-party software developer, refer to the Sage 50-Canadian Edition SDK as there are some methods available to import transactions.

I have a third-party developer but I don't see where these other methods are described. Can you direct me? Thanks in advance.

Parents
  • 0
    This is from the dev-import.pdf manual that is included with the Sage 50 SDK:

    Purchase Invoices and Purchase Quotes
    To add a purchase invoice, use the <purinvoice> transaction type. To add a purchase quote,
    use the <purquote> transaction type. Within the tags, there is one vendor line, one transaction
    option line, and one or more detail lines.

    To import a Purchase Invoice, change PurQuote to PurInvoice, and paste this text into a file with .IMP as the extension to the filename :

    <Version>
    "12001", "1"
    </Version>
    <PurQuote>
    <! This is the vendor line "name"
    "UNIVERSAL CONSTRUCTION"
    <! This is an option line
    <! "no. of details", "quote no.", "entry date", "ship date", "total amount", "disount rate",
    <! "discount days", "net days", "freight amt", "tax information"
    "1","203","3-15-2000", ,"69.98","2.00","30","60","10.00","GST","0","1","7.00","0.70"
    <! This is a detail line
    <! "item no.", "quantity", "price", "amt", "tax information"
    "C1020","20.0000","2.6000","52.00","GST","0","1","7.00","3.64","PST Charged","0","0","7.00","3.64"
    </PurQuote>
Reply
  • 0
    This is from the dev-import.pdf manual that is included with the Sage 50 SDK:

    Purchase Invoices and Purchase Quotes
    To add a purchase invoice, use the <purinvoice> transaction type. To add a purchase quote,
    use the <purquote> transaction type. Within the tags, there is one vendor line, one transaction
    option line, and one or more detail lines.

    To import a Purchase Invoice, change PurQuote to PurInvoice, and paste this text into a file with .IMP as the extension to the filename :

    <Version>
    "12001", "1"
    </Version>
    <PurQuote>
    <! This is the vendor line "name"
    "UNIVERSAL CONSTRUCTION"
    <! This is an option line
    <! "no. of details", "quote no.", "entry date", "ship date", "total amount", "disount rate",
    <! "discount days", "net days", "freight amt", "tax information"
    "1","203","3-15-2000", ,"69.98","2.00","30","60","10.00","GST","0","1","7.00","0.70"
    <! This is a detail line
    <! "item no.", "quantity", "price", "amt", "tax information"
    "C1020","20.0000","2.6000","52.00","GST","0","1","7.00","3.64","PST Charged","0","0","7.00","3.64"
    </PurQuote>
Children

*Community Hub is the new name for Sage City