I see - that's interesting
The record_deleted field exists in the odbc driver but as it is always 0 - I assumed it was not used.
I will try a re index & compress - would you recommend performing this maintenance regularily?
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Search found 9 matches
- 04 Sep 2018, 16:32
- Forum: Sage 50 UK version General Help
- Topic: SOP_ITEM table issues
- Replies: 6
- Views: 4911
- 22 Aug 2018, 16:34
- Forum: Sage 50 UK version General Help
- Topic: SOP_ITEM table issues
- Replies: 6
- Views: 4911
SOP_ITEM table issues
I'm finding the SOP_ITEM table accessed through the ODBC driver contains lines of Sales orders lines that have been deleted. For example - when I create a line on a SO and save, a line entry is created in SOP_ITEM. If I then delete this line by pressing F8, the entry is not deleted in the SOP_ITEM ...
- 31 May 2017, 08:10
- Forum: Sage 50 UK version General Help
- Topic: Invoices Update Ledgers
- Replies: 2
- Views: 2458
Re: Invoices Update Ledgers
Hi Bruce, Thanks for your response, S̶o̶ ̶t̶h̶e̶ ̶f̶i̶r̶s̶t̶ ̶l̶i̶n̶e̶ ̶o̶n̶ ̶a̶l̶l̶ ̶o̶f̶ ̶o̶u̶r̶ ̶i̶n̶v̶o̶i̶c̶e̶s̶ ̶w̶i̶l̶l̶ ̶b̶e̶ ̶p̶r̶o̶d̶u̶c̶t̶ ̶c̶o̶d̶e̶ ̶"̶M̶"̶ ̶a̶n̶d̶ ̶t̶h̶e̶n̶ ̶t̶h̶e̶ ̶2̶n̶d̶ ̶l̶i̶n̶e̶ ̶w̶i̶l̶l̶ ̶b̶e̶ ̶p̶r̶o̶d̶u̶c̶t̶ ̶c̶o̶d̶e̶ ̶"̶S̶3̶"̶ ̶-̶ ̶w̶o̶u̶l̶d̶ ̶S̶A̶G̶E̶ ̶b̶e̶ ̶r̶e̶a ...
- 30 May 2017, 16:13
- Forum: Sage 50 UK version General Help
- Topic: Invoices Update Ledgers
- Replies: 2
- Views: 2458
Invoices Update Ledgers
Good Afternoon, We're having a strange issue with Sage 50. We have started using the Sales Order -> Sales Invoice system built into SAGE as opposed to raising the invoices in a separate software and just manually putting the invoice on a customers account using "Batch Invoice". However there is a ...
- 09 Jan 2017, 15:47
- Forum: Sage 50 Report Designer
- Topic: Multiple "Details" sections
- Replies: 5
- Views: 4560
Re: Multiple "Details" sections
Hi Bruce, that looks fantastic thanks for the help!
I suspected that it would involve repeating the same section and overlaying text but wasn't sure on how to implement as the report designer isn't the most intuitive.
I'll try this later today and let you know the results!
I suspected that it would involve repeating the same section and overlaying text but wasn't sure on how to implement as the report designer isn't the most intuitive.
I'll try this later today and let you know the results!
- 06 Jan 2017, 12:44
- Forum: Sage 50 Report Designer
- Topic: Multiple "Details" sections
- Replies: 5
- Views: 4560
Re: Multiple "Details" sections
hey Bruce, thanks for the response, Perhaps it will be easier to illustrate what I am looking to do: http://i209.photobucket.com/albums/bb68/owen_ledge/Report%20Snippet_zpslqryspnn.png This is an example snippet of the report I want to generate - under "Check your order" - I want another list of ...
- 05 Jan 2017, 15:00
- Forum: Sage 50 Report Designer
- Topic: Multiple "Details" sections
- Replies: 5
- Views: 4560
Multiple "Details" sections
Hey, Is it possible to have 2 "details" sections on a report. What I want is 1 "details" section with a filter that only displays lines with stock code "M" then a break section with text and then another "details" section further down the page with a filter that only displays lines with stock code ...
- 25 Feb 2016, 11:30
- Forum: Sage 50 UK version General Help
- Topic: SAGE ODBC
- Replies: 1
- Views: 2023
SAGE ODBC
Hey Guys, Just a quick (but apparently complicated one). I connect SAGE to access through linked tables and run queries on data which are then called from Excel. So Excel connects to Access which connects to SAGE. The issue is that whenever I refresh the query in Excel it requests the ODBC user name ...
- 08 Dec 2015, 09:41
- Forum: Sage 50 UK version General Help
- Topic: SAGE Database Relationships
- Replies: 2
- Views: 2594
SAGE Database Relationships
Hey Guys, Just a quick question really regarding the database "structure" I'm linking SAGE to Access in order to develop systems and automate a lot of currently manual procedures - Im using V22 of SAGE. I'm struggling to get my head around the relationships in the SAGE database - particularly the ...