Archives

 

How to *quickly* retrieve the stored procedure name and parameters from an SSRS report:

In order to do this, you might try the approach of instantiating the report in SSRS and traversing the class like that... but it's a real pain. We're after speed here. 

I happened across this approach and it works great

 

(sigh)

It's year end, and we've gotten a few calls about the GP update requirement to 'backup all the modified ta PRE and POST scripts'

If there's a developer, they can usually do it. Personally, I have a good system of saving all my modified ta scripts to a folder... but not all companies have that. Sometimes the developer is gone... for whatever reason. 

So, how to get that list?

We have some GL accounts that are set up with MDA codes [tables DTA10100 & DTA10200]. Some of them are set up as 'Optional' and some 'Required'

Is there a way to query all accounts currently set to 'Optional' and mass update to 'Required'?

Thank you,

Paul

 

 

Hi all,

 

I'm trying to import in a purchase receiving transaction (shipment invoice) and I'm getting the decimal places error whenever there's a line item that does not have a reference to a PO number.  The only difference between the XML is the PONUMBER field - one has it and imports successfully, the other is missing it and doesn't import successfully.

The following imports in properly:

<taPopRcptLineInsert_Items>
<taPopRcptLineInsert>
<POPTYPE>3</POPTYPE>
<POPRCTNM>RCT007919</POPRCTNM>
<PONUMBER>PO01608</PONUMBER>
<ITEMNMBR>ITEM1</ITEMNMBR>
<VENDORID>ABC</VENDORID>
<RCPTLNNM>16384</RCPTLNNM>
<UNITCOST>147.50</UNITCOST>
<QTYSHPPD>1</QTYSHPPD>
<QTYINVCD>1</QTYINVCD>
<LOCNCODE>WAREHOUSE</LOCNCODE>
</taPopRcptLineInsert>
</taPopRcptLineInsert_Items>

while this gives the decimal error:

<taPopRcptLineInsert_Items>

<taPopRcptLineInsert>
<POPTYPE>3</POPTYPE>
<POPRCTNM>RCT007919</POPRCTNM>
<ITEMNMBR>ITEM1</ITEMNMBR>
<VENDORID>ABC</VENDORID>
<RCPTLNNM>16384</RCPTLNNM>
<UNITCOST>147.50</UNITCOST>
<QTYSHPPD>1</QTYSHPPD>
<QTYINVCD>1</QTYINVCD>
<LOCNCODE>WAREHOUSE</LOCNCODE>
</taPopRcptLineInsert>
</taPopRcptLineInsert_Items>

 

Is it possible in GP payroll to set up employee deductions so it takes ALL of the Deduction or Nothing?

Example an employee has insurance of $200.00 but his net check is only $125.00 - If i cannot take the full $200.00 I want the deduction to be zero.

 

Thanks,

Lois Urban

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3