SageForum for UK versions of Sage 50- Help and support.

It does have a Products module that allows for Stock Control.

John

Sage can't be integrated directly into the site but there are a few options: 1. If you use SagePay as your payment gateway, the latest version of Sage 50 can integrate directly with your SagePay account and downloaded details of sales. 2. There are a number of 3rd party add on applications that will...

You are right, AUDIT_SPLIT does not have a DUE_DATE as it is calculated based on the date of the transaction and the value of SALES_LEDGER.PAYMENT_DUE_DAYS. RECORD_MODIFY_DATE may not do the job for you for a couple of reasons: 1. It changes if the record is updated for any reason, not just because ...

AUDIT_HEADER isn't necessarily a good indicator of whether an item has been paid or not. In reality, the items that get paid are actually in AUDIT_SPLIT (every record in AUDIT_HEADER will have at least one record in AUDIT_SPLIT but possibly more). When an item is paid, the relevant AUDIT_SPLIT recor...

You post them to the same nominal code as the original journals posted by the Nominal Link. You'd give each entry exactly the same details as the original, the only difference being that, where a debit has been posted, you post a credit and vice versa.

John

As the Nominal Link posts journal entries to Sage, they cannot be deleted. To correct the problem, you need to post journals that are the exact opposite of those posted by the link. i.e. where the link has posted a debit, post a credit with the same details.

John

The SDO exposes a set of constants (all of which are documented in the SDO help file) for the Bank_Flag that you should use. As for the reconciled date, it is not exposed at all via the SDO (even on v2012) so there is now way fo you to write to it...

John

Afraid not.

John

How old is the bad debt - I believe that you have to wait 6 months before the VAT can be reclaimed. Assuming it is older that 6 months, raise a credit note on the Customer Account to the Bad Debt nominal code (8200 by default) with the relevant net and tax amounts and tax code. Then, go to Bank -> C...

To set a customer for a Settlement Discount, you enter the percentage you want to use in the Sett. Discount field on the Credit Control tab of the Customer Record - this will then be applied to the VAT Amount when raising invoices. To amend the VAT amount, you need to go to Settings -> Company Prefe...

You go to File -> Restore in Sage.

John

Sage backups normally have an extension of 001 rather than 000. Assuming that the .000 file is a sage backup then the only way it can be accessed is by restoring it into a copy of Sage 50.

John

I'm running v2011 with the full Office 2010 suite installed including Outlook and I have no problems printing.

Can you print any reports at all?

John

It means that you have data corruption. You can try the following: 1. Take a backup. 2. Run the Clear Audit Trail routine with a date of 01/01/1980. 3. In File -> Maintenance, run both ReIndex and Compress. 4. Run Check Data again. If you still have errors, you have the following choices: 1. Restore...

Go to Bank -> Customer, select the customer and the outstanding transactions will appear. Select Pay In Full until the Receipt Amount at top right is zero then Save.

John