Hi all,
Is there a way in Sage50Cloud to automatically create sales invoices based on a spreadsheet/csv file?
I want to be able to use import/macros/python etc to produce a physical invoice via Customers->Invoices and Credits (not simply importing…
Hi,
I am a Business Intelligence Developer in my company and importing data from Sage 50 accounts database into Power BI using sage ODBC driver. Nominal Ledger table has data at month level but now, our requirement is data at the invoice level. There…
In trying to develop an Invoice Import template for our production environment, I have been testing it in our Sample Company in Bus Works (2019). I can't seem to get past a "unknown sales tax id" exception. I have attached the csv file and an image of…
Hello,
I'm new to Sage 50 and I am currently looking into automating uploads for employee expenses and external invoices. From what I have seen so far online I under that this can be done from a CSV or text file. However, when looking at various resources…
When using an import tool for the purchase invoice transactions I have found my transaction details are replacing the invoice header details as per the explanation given from Adept below:-
Unfortunately this is a foible of the Sage Activity window…
Problem: Sage Line 50 Accounts is not international trade friendly. Other than Commodity Codes and the allowance to add trade contacts from outside of the company's 'home country', there seems to be little else which makes international trade handling…
One of my clients receives payment from one source for MULTIPLE clients (50+) at a time. I am stuck now. None of the distribution lines are appearing, the full "sales" amount is being applied as Sales Tax, rather than the distribution.
Customer…
Submitting request on behalf of a customer:
Please allow users to import AR Invoices without due dates. Currently the Due Date is a required field and the only workaround for importing is to add an additional column to the imported file with duplicate…
My company receives invoices from sub-contractors that involve multiple job cost codes and line items that have to split into different accounts. There is a lot of data entry involved in inputting the invoice information in order to job cost everything…