XavierMac
Technical User
- Nov 15, 2008
- 7
Hello. I'm trying to obtain the freight charges from an invoice in peachtree. I'm using Crystal Reports 10. Here's the info from Peachtree help.
"RowType
Integer
Identifies what kind of row this is. Valid values include:
0 => JrnlRowType_Normal (A general-type journal transaction row.)
1 => JrnlRowType_CGS (The cost of sales row. This row is generally not seen in the program.)
2 => JrnlRowType_InvChg (The opposite side of the cost of sales row above.)
3 => JrnlRowType_JobOnly
4 => JrnlRowType_Discount (This row may be present in a receipt or a payment. The row amount represents the discount amount applied from this check to the related invoice.)
5 => JrnlRowType_SalesTax (The row associated with sales tax in sales or receipt transactions.)
6 => JrnlRowType_Freight (The freight amount calculated for sales transaction.
7 => JrnlRowType_BelowZero
_COGS => (A system-generated cost of sales row used in inventory costing. This is not directly related to any particular header.)
8 => JrnlRowType_BelowZero
_InvChg (A system-generated row inventory adjustment row used in inventory costing. This is not directly related to any particular header.)
9 => SortJob_AssemblyUnbuild
_COGS (A system-generated cost of sales row used in inventory costing when building and unbuilding assemblies. This is not directly related to any particular header.)
10 => SortJob_AssemblyUnbuild_
InvChg (A system-generated inventory adjustment row used in inventory costing when building and unbuilding assemblies. This is not directly related to any particular header.)
"
So I should enter {RowType} = 6 as a formula and enter the field into the report right? Well I've already used {RowType} = 1 due to the format that I need the report to be. How can I get this data retrieved? Is there a formula or something i should know about. I know I'm missing something I just can't pinpoint what it is. Any help would be greatly appreciated. BTW, JrnlRowType_Freight is not a field in peachtree's database.
"RowType
Integer
Identifies what kind of row this is. Valid values include:
0 => JrnlRowType_Normal (A general-type journal transaction row.)
1 => JrnlRowType_CGS (The cost of sales row. This row is generally not seen in the program.)
2 => JrnlRowType_InvChg (The opposite side of the cost of sales row above.)
3 => JrnlRowType_JobOnly
4 => JrnlRowType_Discount (This row may be present in a receipt or a payment. The row amount represents the discount amount applied from this check to the related invoice.)
5 => JrnlRowType_SalesTax (The row associated with sales tax in sales or receipt transactions.)
6 => JrnlRowType_Freight (The freight amount calculated for sales transaction.
7 => JrnlRowType_BelowZero
_COGS => (A system-generated cost of sales row used in inventory costing. This is not directly related to any particular header.)
8 => JrnlRowType_BelowZero
_InvChg (A system-generated row inventory adjustment row used in inventory costing. This is not directly related to any particular header.)
9 => SortJob_AssemblyUnbuild
_COGS (A system-generated cost of sales row used in inventory costing when building and unbuilding assemblies. This is not directly related to any particular header.)
10 => SortJob_AssemblyUnbuild_
InvChg (A system-generated inventory adjustment row used in inventory costing when building and unbuilding assemblies. This is not directly related to any particular header.)
"
So I should enter {RowType} = 6 as a formula and enter the field into the report right? Well I've already used {RowType} = 1 due to the format that I need the report to be. How can I get this data retrieved? Is there a formula or something i should know about. I know I'm missing something I just can't pinpoint what it is. Any help would be greatly appreciated. BTW, JrnlRowType_Freight is not a field in peachtree's database.