Supplier Ledger not reflecting credit that was offset against invoice
Dear MYOB Community, I have attached some diagrams to illustrate the issue I’m facing: The first diagram shows an invoice with a credit applied: $1,608.20 minus $740.64, resulting in $867.56. The second diagram is a snippet of the respective purchase journals. The third diagram is the Supplier Ledger Report, which does not reflect the credit correctly. Instead, the two amounts are added together, displaying $2,348.84 ($1,608.20 plus $740.64) in both the Debit and Credit columns. The Supplier Ledger Report is the standard report found under ‘Purchases / Supplier’. Could you please advise if we are setting off the credits incorrectly? Thank you.
Reports exporting to excel
I suddenly can't export any reports to excel and keep getting the error message: "custldgr.xlt' cannot be accessed. The file may be corrupted, located on a server that is not responding, or read only". How do I fix this please? I can export to PDF or CSV with no problems. I use this a lot with my reports, so hopefully it is a straight forward and quick fix!
Report of Supplier Transactions by Acct
Hi, I'm hoping someone can help me out with a report I can't seem to generate? We need to audit our purchase figures against those lodged by our suppliers with our buying group BUT it needs to exclude freight charges & discounts given. The 'Purchases [Supplier Detail]' report is almost perfect only I can't filter the GL accounts included in the report. Is there another report that will achieve closer to what I need, or is the best bet to export 'Purchases [Supplier Detail]' report and manipulate in excel? I'd prefer not to as it's a large number of suppliers and need to generate monthly reports. Thanks!
Job Activity Report not including all expenses
When I run the Job Activity (Summary and Detail) Report - it does not pick up one of the expense accounts (wages and salaries) except for one employee. However, it does pick up associated expense accounts (superannuation and allowances) for ALL employees. I have been using this report for years with no problems. I have cleared the cache in the local app data file. Can you please suggest another solution.
Analyse Sales [Item] Report - Sold ITEM displaying as NEGATIVE but this is not correct.
Hi All, We have another glitch in our Analyse Sales [Item] Report that we have noticed today. One product is showing as a NEGATIVE which is not correct and throws sales figures out alot. It makes us wonder what other figures are out or not correct. It conflicts with data in other reports. This has happened before and Earl_HD assisted with running some script. Maybe you can assist again Earl, thanks? Screenshot Thanks Nathan
