x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 4 replies
  • Subscribers 75 subscribers
  • Views 1952 views
  • Users 0 members are here
Browse Forums
Announcements
78
topics
166
replies
General Discussion
5k
topics
16k
replies
Installation and Upgrades
977
topics
2k
replies
Inventory, Projects, and Departments
337
topics
1k
replies
Payables and Receivables
1k
topics
4k
replies
Payroll
1k
topics
3k
replies
Reconciliation and Banking
317
topics
995
replies
Reporting and Analytics
206
topics
399
replies
Soutien Technique - Français
626
topics
1k
replies
Year End Activities
223
topics
595
replies
Sheri M

Hi there I am trying to help someone import journal transactions from a POS systems in a CSV format and I cannot find a record layout anywhere.

Posted By

We were finally able to get by all of the errors but upon (what we thought was a successful completion),we could not locate the transactions.  This is the format I was able to get the furthest with: Its in Excel below but saved as CSV

Date Reference Number of Distributions Currency Exchange Rate G/L Account Description Amount Transaction Number Recur Number Recur Frequency
10/17/2018 10/17/18 Cash for De 3 1020-0300 Tender $0.02 1 0 0
10/17/2018 10/17/18 Sales PLANT 3 4022-0300 Department (Sales) -$0.01 1 0 0
10/17/2018 10/17/18 Sales DRIED 3 4023-0300 Department (Sales) -$0.01 1 0 0
  • 0

    Hi

    You must format the text file a certain way. See KB 10186

    Hope this helps.

  • 0 in reply to DeneshS

    It did help.  Thank you so much.   I had to demoralize the layout to include a date and header for each record. Do you know if there is any way to include an account reference is in the layout?    It seems very specific with no mapping tools. 

    We are also receiving supplier invoices for multiple retail stores summarized by account-dep to post to AP.  Do you have a layout for this?  I our actual iitem level inv management  is performed in different software.  

  • 0 in reply to Sheri M

    The method for generating Purchase Invoices and Sales invoice are very different, more so because these are linked accounts in Sage 50 (AP and AR)

    If you generate an .IMP file using KB  91392 and open it in notepad, you can have a look at the format. That article indicates that if you email a sales invoice, it will fire out a purchase invoice IMP. If you want more detailed mapping info on the text format, have a look at KB 41370. As an alternative, if you weren't concerned about getting too technical, you can have a look at our partners at http://sagepss.com/Solutions.aspx?p=6. Some on here have created their own solutions for importing AP and AR.

  • 0

    Sheri M 

    I recommend you try the following company from the Sage Development Partners!

    IntegraPortation sagepss.com/Solution.aspx
    IntegraPortation is the ultimate software for importing data into Sage 50, adaptable to your needs. Convenient, inexpensive, this software will help you avoid duplicate data entry by reducing the risk of error and wasted time.
    Compatible With: Sage 50-Canadian Edition [Simply], Versions 2015 , 2016 , 2017 , 2018
    DetailsProduct SpecificationReviews

    IntegraPortation is the ultimate software for importing data into Sage 50, adaptable to your needs. Convenient, inexpensive, this software will help you avoid duplicate data entry by reducing the risk of error and wasted time.

    If you use other software to make your inputs such as billing or customer orders or purchase order or supplier invoice, import your transactions into Sage 50 in one click.

    We  recently add the function of importing  supplier price list in the inventory module.

    No need to reformat your data to make it compatible with the function Import Sage 50.

    Supports Multi-Currency.

    Example of use

    • You receive an excel or csv file your payroll service we automate the Import-general log of transactions
    • You are using an Access database for billing transferring the sales invoices into Sage 50
    • You want to update the supplier price list in inventory module.
    • You have software your order and purchase non compatible with Sage 50, Integra-Portation will do the bridge with Sage 50 and import transactions.

    We can customize it to your needs.

    Business Needs: EDI - Electronic Data Interchange, EDI, Sales Order Entry, Import/Export, G/L Posting Control, General Accounting, Multi-Company Processing, Sales Order Entry, Purchase Order Entry

*Community Hub is the new name for Sage City