Craig167
Contributing Partner
Joined 7 years ago
User Profile
User Widgets
Contributions
Import error 4077 when updating ITEM fields
I receive a 4077 error when importing ITEM fields. I found other similar posts have been solved by running a script over the data file. I am wanting to update price information as well, and it seems that this may also be a problem when importing. Will the script fix these issues? If so, how do I go about actioning the fix? Our data file is online and the version is accountright plus AU 2022.9.0 Build 2022.9.24.7350 File Id: 4 Regards, CraigSolved481Views0likes3CommentsRe: Analyse Sales Report doesn't match the P&L. Freight not included.
Hi Steven, Thanks for your explanation, and I understand the principle. I will endeavour to put all of my freight above the line in future to avoid this problem. I am attempting to identify what I have charged all of my debtors on a monthly basis. Ideally, I want a report that I can manipulate in excel. Is this possible? or can you offer any solution? Regards, Craig1.3KViews0likes2CommentsRe: Analyse Sales Report doesn't match the P&L. Freight not included.
Hi Steven, I understand your point, however I would expect a customers sales report to show how much I have invoiced to them for the period. We do only use the sales module for sales and don't ever apply receive money to sales income, so our P&L should be a close check. We apply a freight charge on most invoices now, so the amount is significant enough to be considered in our analysis. I do have a freight item-code, that we use sometimes, linked to the freight income account and those sales get added in but the freight doesn't. (therefor some freight is included and some not) I am seeking a customer sales report that tells me how much my customers have purchased from me on a monthly basis. I would choose theCustomersales analysis report and expect it to show how much was charged. (plus/minus GST) Is there any report that I can use? Kind regards, Craig1.3KViews0likes4CommentsAnalyse Sales Report doesn't match the P&L. Freight not included.
My Analyse Sales report doesn't match the profit and loss report. When I invoice freight to a customer, the freight amount is not included in Analyse Sales report, yet is is included in the sales total on the profit and loss. I have been trying to find a multi-report sales report that either includes the freight or allows me to extract the freight on sales invoices. The sales reports just don't match the debtors ledger. I am essentially trying to see what each debtor is being invoiced each month. Any suggestions or solutions?Solved1.3KViews0likes6Comments