A get/change operation on table ‘pm1099PeriodDtl’ failed accessing SQL Data – Invalid column name ‘TEN99FATCAFILEREQ’

This message occurred during check batch posting process after the GP was upgraded from GP 2010 to GP2015.  There were no upgrade errors.  Looks like the PM00204 table was not upgraded, hence was missing the field.    Adopted below process to add the new field :

1.Backup your company database

2. Run this query against company database

Select * into PM00204_Safe from PM00204

3. Navigate to Dynamics GP >> Maintenance >> SQL

4. Select company database and select purchase 1099 period detail table.

5. Tick mark drop table and drop auto procedure and process

6. Tick mark create table and create auto procedure and process

7. Run this query against the company database

insert into [dbo].[PM00204]
      ([VENDORID],[TEN99TYPE],[YEAR1],[PERIODID],[TEN99BOXNUMBER],[TEN99AMNT],[TEN99FRNORUSDTL],[TEN99STATECD],[TEN99STATIDNUM],[TEN99TAXEXMTCUSIPNUM],[TEN99DIRSALECB],[TEN99STATNMBR]) 
select [VENDORID],[TEN99TYPE],[YEAR1],[PERIODID],[TEN99BOXNUMBER],[TEN99AMNT],[TEN99FRNORUSDTL],[TEN99STATECD],[TEN99STATIDNUM],[TEN99TAXEXMTCUSIPNUM],[TEN99DIRSALECB],[TEN99STATNMBR] from PM00204_SAFE

Cheers!
Sanjay

 

The pick list reconcile process can’t continue when manufacturing order records are in use

The picklist reconcile process can’t continue when manufacturing order records are in use, error message pops up when inventory reconciliation is done at GP Environment where manufacturing module is installed.

Execute the script against the company data base, locate the manufacturing  record which is in use and have it closed.

SELECT *
FROM   mop10223 
WHERE  manufactureorder_i IN (SELECT DISTINCT a.manufactureorder_i 
                              FROM   mop1400 b, 
                                     wo010032 a 
                              WHERE  a.manufactureorderst_i <> 8 
                                     AND a.manufactureorder_i = 
                                         b.manufactureorder_i 
                                     AND b.itemnmbr IN (SELECT DISTINCT itemnmbr 
                                                        FROM   pk010033 
                                                        WHERE 
                                         ( ppn_i >= '' 
                                           AND ppn_i <= 
       'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' 
                                                               ) 
                                                                OR 
                                         ( 
                                         itemnmbr >= '' 
                                         AND itemnmbr <= 
                                             'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' 
                                                                   ) 
                                                                   AND 
                                         locncode <> '') 
                                     AND b.locncode <> '' 
                                     AND a.manufactureorder_i <> '')

EEYORE :: Don’t bother … delete the record.

Christopher Robin :: Just makes sure all users are out of the system.

Cheers!

Dynamics GP – Activity Tracking – Navigation & Tables

How to access activity tracking through GP Application:

Setup                ::  Tools -> Setup -> System -> Activity Tracking

Inquiry              ::  Inquiry -> System -> Activity Tracking

Remove            ::  Tools -> Utility -> System -> Activity Detail

 

How to access activity tracking through SQL

Transaction Table ::  SY05000

Setup Table            ::  SY04300

Both table are located at system database.

Cheers!

Sanjay

GP Constants – System Batch Headers SY00500

Batch headers - SY00500

TableFieldConstantValue
SY00500Series1All
SY00500Series2Financial
SY00500Series3Sales
SY00500Series4Purchasing
SY00500Series5Inventory
SY00500Series6Payroll - USA
SY00500Series7Project
SY00500BACHFREQ1Single Use
SY00500BACHFREQ2Weekly
SY00500BACHFREQ3Biweekly
SY00500BACHFREQ4Semimonthly
SY00500BACHFREQ5Monthly
SY00500BACHFREQ6Bimonthly
SY00500BACHFREQ7Quarterly
SY00500BACHFREQ8Miscellaneous
SY00500BCHEMSG11Recurring batch posted too many times
SY00500BCHEMSG12Series is missing or invalid
SY00500BCHEMSG13Missing or invalid system posting settings
SY00500BCHEMSG14Batch currently being posted
SY00500BCHEMSG15Batch currently being edited
SY00500BCHEMSG16User posting access denied
SY00500BCHEMSG17Next Audit Trail Code invalid
SY00500BCHEMSG18No transactions found to post
SY00500BCHEMSG19Batch Source is missing or invalid
SY00500BCHEMSG110Batch Number is missing or invalid
SY00500BCHEMSG111GL posting date is invalid
SY00500BCHEMSG112Batch has not been approved for posting
SY00500BCHEMSG113Actual batch total does not equal the control batch total
SY00500BCHEMSG114Actual transaction number does not equal the control transaction number
SY00500BCHEMSG115Fiscal period for the posting date does not exist
SY00500BCHEMSG116Fiscal period for the posting date is closed
SY00500BCHEMSG117The General Ledger module is not registered
SY00500BCHEMSG118The Receivables Management module is not registered
SY00500BCHEMSG119The Payables Management module is not registered
SY00500BCHEMSG120The Inventory Control module is not registered
SY00500BCHEMSG121The Invoicing module is not registered
SY00500BCHEMSG122The United States Payroll module is not registered
SY00500BCHEMSG123Fatal posting error occurred. Please revert to backup.
SY00500BCHEMSG124Fatal posting error occurred. Please revert to backup.
SY00500BCHEMSG125Actual number of journal entries does not equal the control number.
SY00500BCHEMSG126Another user is editing this batch. Some information may not be updated.
SY00500BCHEMSG127The Sales Order Processing module is not registered.
SY00500BCHEMSG128The Bill of Materials module is not registered.
SY00500BCHEMSG21The Receivables Management module setup information is missing or damaged
SY00500BCHEMSG22The Payables Management module setup information is missing or damaged.
SY00500BCHEMSG23The General Ledger module setup information is missing or damaged.
SY00500BCHEMSG24The Inventory Control module setup information is missing or damaged.
SY00500BCHEMSG25The Invoicing module setup information is missing or damaged.
SY00500BCHEMSG26The United States Payroll module setup information is missing or damaged.
SY00500BCHEMSG27The Inventory Control module is being reconciled.
SY00500BCHEMSG28The Inventory Control module is changing valuation methods.
SY00500BCHEMSG29The Inventory Control module is changing decimal places.
SY00500BCHEMSG210The Inventory Control module is performing a year end close.
SY00500BCHEMSG211Not enough system resources. Please close some windows.
SY00500BCHEMSG212The Multicurrency setup information is missing or damaged.
SY00500BCHEMSG213The functional currency is missing.
SY00500BCHEMSG214This company does not have access to the selected functional currency.
SY00500BCHEMSG215The functional currency for this company is inactive.
SY00500BCHEMSG216The Purchase Order Processing module setup information is missing or damaged
SY00500BCHEMSG217The General Ledger posting date is missing or invalid.
SY00500BCHEMSG218The Bill Of Materials module setup information is missing or damaged.
SY00500BCHEMSG219There are no Released transaction.
SY00500BCHEMSG220The Euro Currency ID is inactive
SY00500BCHSTTUS0Available.
SY00500BCHSTTUS1Batch is currently posting.
SY00500BCHSTTUS2Batch is currently being deleted.
SY00500BCHSTTUS3Batch is currently receiving transactions from outside the module.
SY00500BCHSTTUS4Batch is done posting.
SY00500BCHSTTUS5Batch is currently being printed.
SY00500BCHSTTUS6Batch is currently being updated.
SY00500BCHSTTUS7Batch was interrupted during posting.
SY00500BCHSTTUS8Batch was interrupted during printing.
SY00500BCHSTTUS9Batch was interrupted during updating of tables.
SY00500BCHSTTUS10Recurring batch has application errors and one or more transactions did not post.
SY00500BCHSTTUS11Single-use batch has application errors and one or more transactions did not post.
SY00500ORIGIN1Batch from the transction entry window
SY00500ORIGIN2Batches from the Cash receipts Entry form
SY00500Workflow_Approval_Status1Not Submitted
SY00500Workflow_Approval_Status2Submitted
SY00500Workflow_Approval_Status3No Approval Needed
SY00500Workflow_Approval_Status4Pending Approval
SY00500Workflow_Approval_Status5Pending Changes
SY00500Workflow_Approval_Status6Approved
SY00500Workflow_Approval_Status7Rejected
SY00500Workflow_Approval_Status8Workflow Ended
SY00500Workflow_Approval_Status9Workflow Not Activated
SY00500Workflow_Approval_Status10Workflow Deactivated
SY00500Workflow_Priority1Low Priority
SY00500Workflow_Priority2Normal Priority
SY00500Workflow_Priority3High Priority
Batch headers - SY00500