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

Search found 9 matches

by owen_legend
04 Sep 2018, 16:32
Forum: Sage 50 UK version General Help
Topic: SOP_ITEM table issues
Replies: 6
Views: 4911

Re: SOP_ITEM table issues

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?
by owen_legend
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 ...
by owen_legend
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 ...
by owen_legend
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 ...
by owen_legend
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!
by owen_legend
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 ...
by owen_legend
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 ...
by owen_legend
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 ...
by owen_legend
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 ...