Calendar Maintenance

HelpID: 502622138

The GP PowerPack Calendar is used by many parts of the system to manage business days. The window has the ability to maintain an unlimited number of different calendars, such as one for each Country.

The Calendar is available if Tweaks is registered.

Navigation: Tools >> Setup >> Company >> Calendar Maintenance.

Enter a Calendar ID, then enter the list of Holidays/Down Days.

You can also Copy-Paste a list from Excel.

The spreadsheet must have three columns:

• Calendar ID
• Holiday Date/Down Date
• Description (this is optional)

You can have column headers but do not copy them. Copy only the data. Then click the PASTE button.

The “next business day” logic is contained in a SQL stored procedure called wspGetNextBusinessDay. You can edit this to alter how the “next business day” logic is calculated inside GP. The Source input parameter maps to these GP sources:

1 = AP Check Printing – default to next day if today is holiday

2 = AP EFT File Generation – look ahead for next day holidays

3 = Payroll Direct Deposit – default to prior business day if payday is holiday

4 = AR EFT Collections – use exact next business day

5 = Purchase Order due dates – standard next business day

6 = Sales Order ship dates – standard next business day

0 = Default behavior – simple forward iteration

If you want to use the GP PowerPack Calendar for other purposes you can define your own Source. We suggest using a value over 100 to allow for possible expansion above 6 by WilloWare.

At this time only 2 is being used for Print Payables Checks.