Hello guys
I have done an upgrade from Sage 300 v6.0 to Sage 2017 . Upgrade was successful no Error no glitches but My customized reports with peresoft cashbook to print PV print only half information. below are my tables
CBBTCL
CBBTHD
CBBTDT
NB: when you open reports in Crystal report...
sage accpac can not connetc to your database because an element of your database software is incompatible with the current version (using Sage Accpac 6.0 pu1 and MSSQL SERVER 2008 enterprise edition )
i ve created a view on the table
USE [domdat]
GO
/****** Object: View [dbo].[Domod] Script Date: 03/15/2012 09:21:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Batch submitted through debugger: SQLQuery7.sql|11|0|C:\Users\ATG_Demo\AppData\Local\Temp\~vs11E0.sql
CREATE...
here is the script of the table
USE [domdat]
GO
/****** Object: Table [dbo].[OEORDD] Script Date: 03/15/2012 09:18:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[OEORDD](
[ORDUNIQ] [decimal](19, 0) NOT NULL,
[LINENUM]...
Ttrying to run day end processing with accpac 6.0 and getting this error
error :journal header record already exists
error :Day end could not process all transaction
I have a client that use OE but he got a funny way of calculation by doing the Unit price * Quantity * the lenght to get his extensive amount. Nowing Accpac only use the unit price * the quantity to get the extensive amount ....
any way of doing this ........
CREATE TRIGGER trgInsteadOfUpdate1 ON dbo.Domod
INSTEAD OF INSERT
AS
-- Insert into Region
UPDATE OEORDD
SET EXTINVMISC != 0
FROM OEORDD INNER JOIN
Domod ON OEORDD.ORDUNIQ = Domod.ORDUNIQ
GO
kindly tell da problem want to update a table from a...
Hi guys,We using 5.5A and have a problem posting to a new year(2010) that was created on the 1st of April. i get this error, "Damaged data. Fiscal set 2012 LSL not found for account 5831COIAH."
What I have realised is that some errors did come when we created the year in GL, one of them was...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.